﻿CREATE TABLE [dbo].[Inventory] (
    [inventoryID]     BIGINT          IDENTITY (1, 1) NOT NULL,
    [transferDate]    DATETIME        NOT NULL,
    [inventoryItemID] INT             NOT NULL,
    [quant]           FLOAT           NOT NULL,
    [userID]          INT             NOT NULL,
    [insertDate]      DATETIME        NOT NULL,
    [notes]           NVARCHAR (3000) NULL
);







